package com.pond.pond.mapper;

import java.util.List;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.pond.pond.domain.Pond;
import com.pond.pond.domain.PriceSegment;
import com.pond.pond.domain.dto.PondDTO;
import com.pond.pond.domain.vo.PondNameOptionsVo;
import org.apache.ibatis.annotations.Param;

/**
 * 鱼塘管理Mapper接口
 *
 * @author ruoyi
 * @date 2025-05-13
 */
public interface PondMapper extends BaseMapper<Pond>
{
    Pond selectPondById(Long id);

    List<Pond> selectPondList(Pond pond);

    // 支持批量查询多个 pondId 的价格分段
    List<PriceSegment> selectPriceSegmentsByPondIds(@Param("pondIds") List<Long> pondIds);

    List<PondNameOptionsVo> selectPondOptionList();

    int insertPond(Pond pond);

    int updatePond(Pond pond);

    int deletePondById(Long id);

    int deletePondByIds(Long[] ids);

    int updatePondBackground(@Param("pondId") Long pondId, @Param("backgroundUrl") String backgroundUrl);

    int insertPriceSegment(@Param("list") List<PriceSegment> list);

    int deletePriceSegmentsByPondId(Long pondId);

    // 根据钓场ID查询该钓场下所有塘口的 fishTypes 字段
    List<String> selectFishTypeStringsByDeptId(@Param("deptId") Long deptId);
}

